Model Table ACCOUNT DATE

Attributes

AttributeDescription (where applicable)
Account Date StringDate as string, fixed format, not NLS dependent
Account MonthAccount Month
Account Month NoAccount Month Number
Account Month ShortMonth short, 3 char, NLS dependent
Account QuarterQuarter, not NLS dependent
Account WeekdayWeek Day
Account Weekday NoWeek Day Number
Account YearYear, NLS dependent
Account Year MonthYear month
Year (Week based)Year, NLS dependent
Current Month FlagCurrent month flag, day in current month
Current Year FlagCurrent year flag, day in current yea
Last 12 Months FlagLast 12 months flag, day between curr month-1 and curr month-12
Last 24 Months FlagLast24 months flag, day between curr month-24 and curr month-1
Account DateAccount Date
Account Week NoWeek Number

Hierarchies

HierarchyLevel
AccountMSHy
Account Year
Account Quarter
Account Month
AccountMFHy
Account Date
Account Month
Account Quarter
Account Year
AccountWSHy
Account Week No
Account Year
AccountWFHy
Account Date
Account Week No
Account Year

USED BY MODEL(S)

Model Name

Data source Information

The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).

Model TableDW Source view (SQL Server)BI Access ViewReferenced Information SourceRecommended Access Type
ACCOUNT DATEDIM_BI_TIME_TMDIM_BI_TIME_BIDIM_BI_TIMEOn Line